UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Bqd7xLPgM1301xSKS/QpfNV2Ro4WoOz488gTovMp9dI='
WHERE
key_id = 'c3bfc33807bb89103b26e7b6f611194e27d9f9193b706543d53cab1825f5d4d5'
AND (
token = 'Bqd7xLPgM1301xSKS/QpfNV2Ro4WoOz488gTovMp9dI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)