UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CBqT12+9ep++6lHXdfBcz95sL2uzgwUFGDEEhTp/7xA='
WHERE
key_id = 'e3090a4b1994837a8a0eac1f93c34c850c9da7c10e00542016ab2eb6ebc59d5b'
AND (
token = 'CBqT12+9ep++6lHXdfBcz95sL2uzgwUFGDEEhTp/7xA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)