UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0pK+21gKtgY2RiQVyd3THGMlTNESv/Adaa/0DZVw4Ss='
WHERE
key_id = 'eb86e29b6cdadf54ab88fd6793484bfe801f00a2c8c59f0af3fab71b2b9ec027'
AND (
token = '0pK+21gKtgY2RiQVyd3THGMlTNESv/Adaa/0DZVw4Ss='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)