UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8FscFoGtJV5UORRCx2UqTUYpxC9KIw723aA51suGqiY='
WHERE
key_id = 'a4acb38409def8c363d71187780e32cf2b98fd004b80b799c18f5b38fdd6e22c'
AND (
token = '8FscFoGtJV5UORRCx2UqTUYpxC9KIw723aA51suGqiY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)