UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G7UYMsmPwbyz98IwW0eOOPO+7Narpqh8egcyFiI16oc='
WHERE
key_id = '08fedd0c092a009bcb531ca392d35c802ea4ef71216b09778246496b06c64c47'
AND (
token = 'G7UYMsmPwbyz98IwW0eOOPO+7Narpqh8egcyFiI16oc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)