UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x0updRhyNHUaHc2FqFGXwqmiDatg497T2IxPkDQuAYg='
WHERE
key_id = '6d511827ee5a7cfad894dc22fbccaade4ca2aacf3bd3389381abee3298a6dd67'
AND (
token = 'x0updRhyNHUaHc2FqFGXwqmiDatg497T2IxPkDQuAYg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)