UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fj7KX/fwE8HhaDWxuzLCTytXOQ9yT1SD6r1Ico15LMg='
WHERE
key_id = '477f23b26d8795f9f1ff6c5cffc137bac78c4f6f45806f770abf312cfc0df9d0'
AND (
token = 'fj7KX/fwE8HhaDWxuzLCTytXOQ9yT1SD6r1Ico15LMg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)