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