UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9bmGmvWHvgzlFtM6hTCKA3chEnqPBOY/WTISGZBkXCU='
WHERE
key_id = '452c9fd766f0c3a2991e7cbbc0feae72cc70ced7ded462a8c2b19b12cb9fc680'
AND (
token = '9bmGmvWHvgzlFtM6hTCKA3chEnqPBOY/WTISGZBkXCU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)