UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pKMixma1uKvV9IoYDAkiIJnEfEkRZdykN7jWVH2qWRo='
WHERE
key_id = '3916e7a7ef528d32dad829435d5d256021521775a42e58af77af39571a3ff5c4'
AND (
token = 'pKMixma1uKvV9IoYDAkiIJnEfEkRZdykN7jWVH2qWRo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)