UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'oj3oIMc7IeJz2R6aL+obo+Bp0gCiFIE8Y60Ze1fl7Rs=' 
WHERE 
  key_id = '11919715564172f6f045c3469e9494e1b2beb834ff59273199a18bdffce9c99d' 
  AND (
    token = 'oj3oIMc7IeJz2R6aL+obo+Bp0gCiFIE8Y60Ze1fl7Rs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032