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