UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OZGhvHBwhhpOiOJ/et80B9yKIpsypbLOg5Eb9xz5G7A='
WHERE
key_id = 'ae2c5eabbba1e44e914e912707b012512901a16d9b984e413863d30d8f717149'
AND (
token = 'OZGhvHBwhhpOiOJ/et80B9yKIpsypbLOg5Eb9xz5G7A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)