UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '11tYXM/9VL2G4y9bVBjVTPf/jHa5K1+d7vvzEHlgFoc=' 
WHERE 
  key_id = 'd703bce6e22b0ff4bda600df2a95501a427aa9a981feeb4eb5b9c07b7b0c676e' 
  AND (
    token = '11tYXM/9VL2G4y9bVBjVTPf/jHa5K1+d7vvzEHlgFoc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00039