UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8lPMSebVocewqQ0s48bb5RVqE2nSia9VTuBR+xgS3+c='
WHERE
key_id = '99b90acb0fa8e24c181a2ac94c7d09bc9d5a547e8edef13358c53ac673114de1'
AND (
token = '8lPMSebVocewqQ0s48bb5RVqE2nSia9VTuBR+xgS3+c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)