UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qSaoCpwEZhtw2twZlRiYmP1GekwlpcbN6IVCqYu/x5Q='
WHERE
key_id = 'dabea2e966375f9ee2ec193fa830fe6402cd60f877168cf392b270c9745678d3'
AND (
token = 'qSaoCpwEZhtw2twZlRiYmP1GekwlpcbN6IVCqYu/x5Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)