UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MzjIdRT4wZBm6qHGleT4168bgC04uO0+myUjEy7Tee8='
WHERE
key_id = 'a22c89ce354e1ac2351f56541b83cac11daa62b9fd214e41df3c3522091eee5e'
AND (
token = 'MzjIdRT4wZBm6qHGleT4168bgC04uO0+myUjEy7Tee8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)