UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DjzCRwXLPH3UvA0GwM0ZxePVY4AKFtFbcCIISDirXYE='
WHERE
key_id = 'ef0a1e4613f69476dc60213d4a44f0faaebef3c9437698ad36b21775d8e2f211'
AND (
token = 'DjzCRwXLPH3UvA0GwM0ZxePVY4AKFtFbcCIISDirXYE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)