UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yOTlcm1lBJ+e9fqmWme7qN+IvY1kosCKB1IRD+QYvgw='
WHERE
key_id = '0e770def16839ec7a97a17dd4905c9223e8dd37d188dabb9bfa3d5ab91d1e506'
AND (
token = 'yOTlcm1lBJ+e9fqmWme7qN+IvY1kosCKB1IRD+QYvgw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)