UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZjaIqL7EUukg7ys0PHaTdP1STn4wlf1wfGj4uPLp2Ys='
WHERE
key_id = '347b1ccd25812b85c35e8969d7709308d2c33af4436298156b2255a060c85440'
AND (
token = 'ZjaIqL7EUukg7ys0PHaTdP1STn4wlf1wfGj4uPLp2Ys='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)