UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OiN6gXRfXVCOy6I3sG6t57p7r2PDAY7xXujeyTu/RZo='
WHERE
key_id = 'e734cf2779e6a8ab561289dd9f6200793bc48a52ece4c06a77651827e032a91a'
AND (
token = 'OiN6gXRfXVCOy6I3sG6t57p7r2PDAY7xXujeyTu/RZo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)