UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K7haf3f16g/Z109c3x9S99zmqyEumBETW7u/BdRkUUY='
WHERE
key_id = 'aefd2f520622a766b1d12b83425061c8018be755c896d78f44f31f9f58f2cbe0'
AND (
token = 'K7haf3f16g/Z109c3x9S99zmqyEumBETW7u/BdRkUUY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)