UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '12d0gBQG9L0N4Wa/XhyTEbh/V+Sg+qIkj4WIFsLWtG4=' 
WHERE 
  key_id = '20b39f3ce4606c38d1420d76d24b90725dbe8eca94cfa91b2cdca4064370fec4' 
  AND (
    token = '12d0gBQG9L0N4Wa/XhyTEbh/V+Sg+qIkj4WIFsLWtG4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021