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