UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3Xs5lDDKmF2Q0FciLRzyzoIsdjdAUTI7X2Kgr7jeZTk='
WHERE
key_id = '26b5966c2628b796607153d8e51a45b31d65e69498e90821d3f9972c864c207b'
AND (
token = '3Xs5lDDKmF2Q0FciLRzyzoIsdjdAUTI7X2Kgr7jeZTk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)