UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+zKTcF12Xlw0hpK7qm5vcNjDQsIJ0bg90SrSIGCXtws='
WHERE
key_id = '3db85686650359872fa8069f9db834d5a4be6c8b1e51e05bd3b29ec748b0255a'
AND (
token = '+zKTcF12Xlw0hpK7qm5vcNjDQsIJ0bg90SrSIGCXtws='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)