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