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