UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c/r0etTTQfh3ko4ZDZc7gy1dLGAJYir0YGGTsDEIK3E='
WHERE
key_id = 'eda52b60c777f84f697b7eb56c8aa1f5d692fdb5f8d0beac8f326936f6a5b21d'
AND (
token = 'c/r0etTTQfh3ko4ZDZc7gy1dLGAJYir0YGGTsDEIK3E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)