UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J7deffOCiich7KYYnSqz0maZft+R3CkRdSNpHS9qWs8='
WHERE
key_id = '3be86f5b2387c547e5520fb75cf5291722b6186f748979db46c648038c86340b'
AND (
token = 'J7deffOCiich7KYYnSqz0maZft+R3CkRdSNpHS9qWs8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)