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